<?php  
include 'mysql.php';
$name = $_POST['name'];
$password = $_POST['password'];

if($name != '' && $password != '')
{
	$sqlReference = 'SELECT `studentID`, `time`, `order_product`, `rmb` FROM `all_order`  WHERE studentID = '.$name; //PHP的连接符是.别记错了
	$result = mysqli_query($link,$sqlReference);
	
}




?>
<!DOCTYPE html>
<html lang="zh">
<head>
	<meta charset="UTF-8">
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<meta http-equiv="X-UA-Compatible" content="ie=edge">
	<title></title>
	<style>
		*
		{
			margin: 0 ;
			padding: 0;
		}
		#wrapper_orderSelect
		{
			width: 100%;
			margin: 0 auto;
			text-align: center;
			overflow: auto;
		}
		#option_orderSelect
		{
			width: 100%;
			background-color: #DDE0CD;
			float: left;
			border-radius: 12px;
		}
		#option_orderSelect div 
		{
			overflow: auto;
			float: left;
			width: 33%;
			height: 30px;
			line-height: 30px;
		}
		.createSelect
		{
			width: 100%;
			/* background-color: #00FFFF; */
			float: left;
			border-radius: 12px;
		}
		.createSelect div
		{
			width: 33%;
			overflow: auto;
			min-height: 30px;
			float: left;
			
		}
	</style>
</head>
<body>
<div id="wrapper_orderSelect">
	<div id="option_orderSelect">
		<div>提交时间</div>
		<div>内容</div>
		<div>价格</div>
	</div>
	<!-- <div class="createSelect">
		<div>2020202020202122222</div>
		<div>周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane </div>
		<div>10000000</div>
	</div>
	<div class="createSelect">
		<div>2020202020202122222</div>
		<div>周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane 
		周杰伦陈奕迅五月天dear Jane </div>
		<div>10000000</div>
	</div>      这些代码用PHP写-->
	<?php  
	 while($rows = mysqli_fetch_assoc($result))
	 {
		 echo '<div class="createSelect">';
		 echo '<div>'.$rows['time'].'</div>';
		 echo '<div>'.$rows['order_product'].'</div>';
		 echo '<div>'.$rows['rmb'].'</div>';
		 echo '</div>';
	 }
	
	
	?>
	
</div>	
</body>
</html>